<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_job_class`;");
CreateTable("CREATE TABLE `phpyun_job_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `sort` int(11) NOT NULL,
  `content` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=953 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_job_class` values('39','0','生物/制药/医疗/护理','5',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('485','72','牙科医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('486','72','麻醉医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('487','72','美容整形师','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('488','72','理疗师','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('489','72','中医科医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('490','72','针灸、推拿','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('491','72','儿科医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('492','72','心理医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('493','72','营养师','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('494','72','药库主任/药剂师','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('495','72','医药学检验','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('496','72','公共卫生/疾病控制','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('497','72','护理主任/护士长','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('498','72','护士/护理人员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('499','72','兽医','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('500','72','验光师','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('501','72','其他','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('484','72','专科医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('483','72','外科医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('482','72','内科医生','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('481','72','医院管理人员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('471','70','其他','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('470','70','医疗器械维修人员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('469','70','医疗器械销售','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('468','70','医疗器械市场推广','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('467','70','医疗设备生产/质量管理','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('466','70','医疗设备注册','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('465','70','医药销售代表','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('464','70','医药销售经理/主管','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('463','70','招投标管理','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('462','70','政府事务管理','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('461','70','医药招商','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('460','70','药品市场推广主管/专员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('459','70','药品市场推广经理','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('458','70','药品生产/质量管理','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('457','70','药品注册','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('456','70','临床数据分析员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('455','70','临床协调员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('454','70','临床研究员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('453','70','医药技术研发人员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('452','70','医药技术研发管理人员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('451','70','化学分析测试员','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('450','70','生物工程/生物制药','0',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('72','39','医院/医疗/护理 ','1',NULL);");
ExcuteSQL("insert into `phpyun_job_class` values('70','39','生物/制药/医疗器械','3',NULL);");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>